﻿
namespace BO.Infrastructure.StaticData
{
    public class SqlConstants
    {
        public class NewsPublish
        {
            public const string TableName = "NewsPublish";
            public const string Id = "NewsId";
            public const string ZoneId = "ZoneId";
            public const string Title = "Title";
            public const string SubTitle = "SubTitle";
            public const string Sapo = "Sapo";
            public const string Avatar = "Avatar";
            public const string DistributionDate = "DistributionDate";
            public const string Url = "Url";
            public const string Source = "Source";
            public const string Content = "Body";
            public const string Author = "Author";
            public const string DisplayStyle = "DisplayStyle";
            public const string NewsTypeIcon = "NewsTypeIcon";
            public const string NewsType = "NewsType";
            public const string NewsRelation = "NewsRelation";
            public const string AvatarDesc = "AvatarDesc";
            public const string InitSapo = "InitSapo";
            public const string Tags = "Tags";
            public const string TagItem = "TagItem";
            public const string Order = "Order";
            public const string OriginalUrl = "OriginalUrl";

            public const string LikeNumber = "LikeNumber";
            public const string FormatedImage = "FormatedImage";
            public const string EncodedTitle = "EncodedTitle";
            public const string Type = "Type";

        }

        public class EmbedGroup
        {
            public const string Id = "Id";
            public const string IsVisible = "IsVisible";
            public const string TemplateId = "TemplateId";
        }

        public class ZoneInEmbedGroup
        {
            public const string ZoneId = "ZoneId";
            public const string SortOrder = "SortOrder";
        }

        public class PhotoPublished
        {
            public const string TableName = "PhotoPublished";
            public const string Name = "Name";
            public const string ImageUrl = "ImageUrl";
            public const string ImageNote = "ImageNote";
        }


        public class NewsLive
        {
            public const string TableName = "NewsLive";
            public const string Id = "Id";
            public const string Title = "Title";
            public const string Content = "Content";
            public const string PublishedDate = "PublishedDate";
        }

        public class SEOMetaNews
        {
            public const string TableName = "SEOMetaNews";
            public const string NewsId = "NewsId";
            public const string MetaTitle = "MetaTitle";
            public const string MetaKeyword = "MetaKeyword";
            public const string MetaDescription = "MetaDescription";
            public const string MetaNewsKeyword = "MetaNewsKeyword";

        }

        public class SEOMetaTags
        {
            public const string TableName = "SEOMetaTags";
            public const string ZoneId = "ZoneId";
            public const string Name = "Name";
            public const string MetaKeyword = "MetaKeyword";
            public const string MetaDescription = "MetaDescription";

        }

        public class NewsContent
        {
            public const string TableName = "NewsContent";
            public const string OriginalId = "OriginalId";
        }

        public class Tag
        {
            public const string TableName = "Tag";
            public const string Id = "Id";
            public const string Description = "Description";
            public const string Name = "Name";
            public const string ThreadId = "ThreadId";
            public const string ThreadName = "ThreadName";
            public const string IsHotTag = "IsHotTag";
            public const string IsThread = "IsThread";
            public const string TemplateId = "TemplateId";
            public const string Content = "TagContent";
            public const string Avatar = "Avatar";
            public const string TagTitle = "TagTitle";
            public const string TagInit = "TagInit";
            public const string TagMetaKeyword = "TagMetaKeyword";
        }

        public class Zone
        {
            public const string TableName = "Zone";
            public const string Id = "Id";
            public const string ParentId = "ParentId";
            public const string Name = "Name";
            public const string Description = "Description";
            public const string ShortUrl = "ShortUrl";
            public const string ParentName = "ParentName";
            public const string ParentShortUrl = "ParentShortUrl";

            public const string SortOrder = "SortOrder";
        }

        public class Video
        {
            public const string TableName = "Video";
            public const string ZoneId = "ZoneId";
            public const string Id = "Id";
            public const string Name = "Name";
            public const string Description = "Description";
            public const string Url = "Url";
            public const string Avatar = "Avatar";
            public const string RelateUrl = "RelateUrl";
            public const string KeyVideo = "KeyVideo";
            public const string PName = "PName";
            public const string Tags = "Tags";
            public const string Views = "Views";
            public const string PublishDate = "PublishDate";
            public const string DistributionDate = "DistributionDate";
            public const string Mp4Url = "Mp4Url";

            public static string EncodedName = "EncodedName";
        }

        public class ZoneVideo
        {
            public const string TableName = "ZoneVideo";
            public const string Id = "Id";
            public const string Name = "Name";
            public const string Url = "Url";
            public const string ParentId = "ParentId";
        }


        public class Vote
        {
            public const string TableName = "Vote";
            public const string ID = "Id";
            public const string Title = "Title";
            public const string StartDate = "StartedDate";
            public const string EndDate = "EndedDate";
            public const string Avatar = "Avatar";
            public const string Sapo = "Sapo";
        }

        public class VoteAnswer
        {
            public const string TableName = "VoteAnswer";
            public const string ID = "Id";
            public const string VoteId = "VoteId";
            public const string Value = "Value";
            public const string VoteRate = "VoteRate";

        }
    }
}
